si_TransactionCollection

EntityType | Independent
Logical Entity Name | si_TransactionCollection
Default Table Name | si_TransactionCollection
Logical Only | NO
Owner | dbo
Definition |
Note |

si_TransactionCollection Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
si_TransactionCollectionID |  | CHAR(10) | NO |
OrchestrationInstanceID |  | CHAR(10) | NO |
TransactionCollectionType |  | CHAR(10) | NO |
ParentTransactionOrchestrationIdentifier |  | CHAR(10) | YES |
SyCampusID |  | CHAR(10) | YES |
InputParameters |  | CHAR(10) | NO |
ProcessingStartTime |  | CHAR(10) | NO |
ProcessingEndTime |  | CHAR(10) | YES |
Status |  | CHAR(10) | NO |
TotalRecordCount |  | CHAR(10) | YES |
SuccessRecordCount |  | CHAR(10) | YES |
FailedRecordCount |  | CHAR(10) | YES |
SuspendedRecordCount |  | CHAR(10) | YES |
UnknownStatusRecordCount |  | CHAR(10) | YES |
InputFileName |  | CHAR(10) | NO |
OutputFileNames |  | CHAR(10) | YES |
Comments |  | CHAR(10) | YES |
UserId |  | CHAR(10) | NO |
DateAdded |  | CHAR(10) | NO |
DateLstMod |  | CHAR(10) | NO |
TS |  | CHAR(10) | NO |
PackageNameId |  | CHAR(10) | YES |

si_TransactionCollection Keys

Key Name | Key Type | Keys
PK_si_TransactionCollectionID | PrimaryKey | si_TransactionCollectionID
UNQ_si_TransactionCollection_OrchestrationInstanceID | Alternate Key | OrchestrationInstanceID
Index_si_TransactionCollection_DateLstMod | Inversion Entry | DateLstMod
Index_si_TransactionCollection_DateAdded | Inversion Entry | DateAdded

si_TransactionCollection Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Si_Packages_PackageName | Non-Identifying | Zero or One to Zero or More |  |  |  | PackageNameId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
Si_Transaction | Non-Identifying | One To Zero or More |  |  |  |  | NO

si_TransactionCollection Check Constraints

Check Constraint Name | CheckConstraint

si_TransactionCollection Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.si_TransactionCollection | NO |  |  |
Physical (Microsoft SQL Server) Does Not Exist | NO |  |  |

si_TransactionCollection Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model

si_TransactionCollection Data Movement Rules

Name | Type | Rule Text/Value